Skip to main content
TrustRadius
Qlik Replicate

Qlik Replicate

Overview

What is Qlik Replicate?

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Read more
Recent Reviews

TrustRadius Insights

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported …
Continue reading

Qlik Replicate Review

9 out of 10
December 18, 2021
Incentivized
We use the Replication to replicate data from Different Sources Databases to Different databases. We use from MYSQL to Oracle, Sybase to …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Qlik Replicate?

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Entry-level set up fee?

  • Setup fee required

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

70 people also want pricing

Alternatives Pricing

What is Oracle GoldenGate?

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

What is Hornetsecurity VM Backup?

Hornetsecurity VM Backup (formerly Altaro) is a backup and replication solution for Hyper-V and VMware virtual machines. VM Backup can manage large infrastructures, with the revamped backup repository providing long-term storage and more efficient use of disk space.

Return to navigation

Product Details

What is Qlik Replicate?

Qlik Replicate (formerly Attunity Replicate) enables organizations to accelerate data replication, ingestion and streaming across a variety of heterogeneous databases, data warehouses, and big data platforms. Boasting hundreds of enterprise users worldwide, Qlik Replicate is designed to move data securely and efficiently, with minimal operational impact. Qlik Replicate provides automated, real-time, and universal data integration across all major source endpoints such as databases, systems like SAP, mainframes and Salesforce and delivers data to streaming systems, data warehouses, and data lakes. On-premises and in the cloud.

Qlik Replicate is Enterprise-Ready. It moves data at high speed from source to target and offers a single pane of glass monitoring of data pipelines across the enterprise, all managed through a graphical interface that automates end-to-end replication. With agentless configuration, administrators and data architects can set up, control, and monitor bulk loads and real-time updates with automated change data capture (CDC) at scale.

Qlik Replicate Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of

Qlik Replicate Video

Move data with minimal operational impact.

Qlik Replicate Integrations

Qlik Replicate Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Informatica RulePoint, Oracle GoldenGate, and HVR are common alternatives for Qlik Replicate.

Reviewers rate Qlik Replicate Productivity 4.7.21 highest, with a score of 8.7.

The most common users of Qlik Replicate are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(49)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported that this tool effectively transfers data from one place to another, improving overall performance and efficiency in the data integration process. One of the primary use cases for Qlik Replicate is ensuring the accuracy and timeliness of data across various storage systems, which is crucial for organizations relying on real-time data analysis for making informed business decisions. Customers have found value in using Qlik Replicate for data warehousing, disaster recovery, cloud migration, and analytics purposes. This powerful tool allows for data replication, synchronization, and integration across multiple databases and storage systems. Users have successfully replicated operational application data from various sources such as Oracle ERP and Salesforce to Microsoft SQL Server BI systems, enhancing business case data pipelines and supporting reporting and dashboards. Additionally, Qlik Replicate has simplified the process of data warehousing and batch processing of streaming data, making it more convenient for users. Organizations have utilized Qlik Replicate to replicate data from brick-and-mortar source system databases to cloud databases, allowing for direct data querying and supporting various reporting needs. Users have also praised Qlik Replicate for its reliability, intuitive user interface, and support for a variety of sources and targets, making it a preferred choice for replicating on-premises data into the cloud. Overall, customers from different segments and sizes have found Qlik Replicate to be a fantastic tool for achieving seamless data replication with ease of configuration, scalability, and customization options.

Stability and reliability: Users have consistently praised Replicate for its stability and reliability, with minimal alerts, failures, or troubleshooting required. Several reviewers have mentioned this as a key benefit of using the software.

Ease of scalability: Many users have found Replicate to be highly scalable in big data integrated projects, which has had a positive financial impact for them. The ability to easily add new source tables to tasks and ensure synchronization with the latest data has been particularly appreciated by users.

Efficiency in handling large amounts of data: Replicate's ability to efficiently handle and capture large amounts of data has been highlighted by multiple reviewers. This makes it a valuable tool for data replication, warehousing, disaster recovery, cloud migration, and analytics tasks.

Latency Issues: Some users have experienced latency in certain tasks and are unsure of the cause. This issue has been mentioned by multiple reviewers, indicating a recurring problem that affects the overall performance and efficiency of the tool.

Limited Documentation and Error Reporting: Several reviewers have expressed the need for more comprehensive documentation and detailed error reporting in the tool. The lack of sufficient documentation makes it difficult for users to troubleshoot issues effectively, leading to frustration and wasted time trying to find solutions.

Challenging Support Experience: Users have voiced their desire for more agile and efficient support. They find the current support experience lacking in responsiveness and quality, highlighting areas that require improvement such as faster response times, better communication, and more knowledgeable support staff.

Users have made several recommendations based on their experiences with Qlik Replicate. Firstly, they suggest trying Qlik Replicate for change data capture (CDC) needs and conducting a proof of concept (POC) to see the benefits and suitability of the software.

Secondly, it is advised to check the hardware requirements, install recommended resources, and test the software in a representative environment with volume. Users also recommend considering any pre-requests, security requirements, and logging setup.

Lastly, many users find Qlik Replicate worth the cost and believe it is an excellent tool for reducing stress during data replication or loading. They suggest getting a demo of the software to better understand its capabilities and determine if it suits the company's needs.

Attribute Ratings

Reviews

(1-23 of 23)
Companies can't remove reviews or game the system. Here's why
Fernando Tonial | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Qlik Replicate is used to data integration allows organization to replicate, synchronize, and integrate data across multiple databases, data warehouses, and other data storage systems.

The main use case for Qlik Replicate is to ensure that data is accurate and up-to-date across my organization's various data storage systems. This is particularly important for organizations that rely on real-time data analysis to inform business decisions, as Qlik Replicate ensures that all relevant data is available for analysis in a timely manner. Some common ways that Qlik Replicate is used include:Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.Overall, Qlik Replicate is a versatile tool that can be used to ensure that data is accurate and up-to-date across an organization's various data storage systems.
  • Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.
  • Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.
  • Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.
  • Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.
  • More detailed documentation with errors that occurred in the tool.
  • More agile and efficient support.
  • It works best if you also use other Qlik products.
  • Few APi integrations are not compatible
Qlik Replicate works very well with relational data platforms, both on premise and in the cloud, for example Oracle, SQL Server, PostgreSQL, MySQL and others, it also works very well with DB2.
If the data source is MongoDB, it is more complicated and currently there is no possibility of sending data to MongoDB.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik replicate to extract data from sources to a decentralized environment to minimize the impact on our production sources. We do this on any data sources that are relevant for our data engineers. We have different types of sources that all need to be replicated and Qlic replicate has done a good job so far for our data sources like Oracle, SAP, and Microsoft SQL servers.
  • It has a really good replication speed.
  • The interface is initiative.
  • It supports many major platforms.
  • It’s a bit heavy for our relative small environment.
  • It works best if you also use other Qlik products.
  • You need experienced people to work with this tool.
Qlic replicate works best if you have a good data specialist that knows what he is doing. If you have many different source platforms, Qlic can make a connection to all. It supports many of the major platforms. If you mainly use one data source platform, the native tooling could better suit your use case. If you have a small company, it probably would be better to look for some cheaper tooling.
November 02, 2022

Qlik Replicate

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Qlik Replicate is used in IT to replicate on-prem data to off-prem Cloud solutions.
  • Replicates data across disparate platforms.
  • Pretty easy to maintain and update
  • Troubleshooting issues can be difficult as errors are not very clear.
  • Logging is minimal and not terribly helpful by default unless you increase the logging levels.
It is well suited for replicating data across disparate data platforms. If your environment only uses one data platform (i.e. only SQL Server, only Oracle, etc.) then you can probably rely upon replication solutions provided by said products.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate to Move Data over from 14 DB2 on-prem servers to AWS cloud. The tool is very easy to configure between any Source and Target. We never had any issues with it so far. It scales to a greater extent, and we can customize it to our need for Replication frequency and the format in which you want the data to be delivered into Target. It was a great suit for us, as we were looking for a tool that can read data from our Journals and not from the physical tables, so the performance of the transaction system is not Impacted. I would definitely recommend Qlik Replicate for other companies looking out for a Replication Tool.
  • Easy to Scale
  • Multiple Endpoint options
  • Options of Output format
  • Logging
  • Alerting
Well suited for scenarios where you want to read from Journals and not from Physical Tables. Data reconciliation is not done with Qlik Replicate.
December 18, 2021

Qlik Replicate Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use the Replication to replicate data from Different Sources Databases to Different databases. We use from MYSQL to Oracle, Sybase to SQL , SQL to Aurora, and Aurora to S3
  • Replication between different databases
  • Customizations
  • Transformations
  • LOB handling
  • Filtering
  • Support wise
  • Support more sources
  • Performance improvements
Specifically when we have different Source and targets triplicate and for CDC data, transaction, and batch processing.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate (formerly Attunity Replicate) to load data from multiple on-prem sources (Oracle and SQL Server DBs) into the Cloud Data warehouse in Azure cloud. Software is easy to set up and configure. Software is very reliable, works great, has a scheduler that some other competitors don't have as well as a job notification process. UI is very intuitive and as long as there are no tricky transformations are deployed, users don't need any training. For heavy-duty transformations to implement, it gets tricky, and transformation functions are not obvious at times. The software supports a variety of sources and targets and works better than competitors. We run daily/weekly/monthly jobs to replicate on-prem data into the cloud and it works very well. We also have a number of near real-time replication jobs and [they] work well too.
  • Performing near-real time replications for 14TB SQL Server DB into Azure EDW
  • Performing near real time replications from 28TB on-prem Oracle DB into Azure EDW
  • Looking for Qlik to support CDS view replications from S4 HANA, both full loads and CDC
  • Better document data transformation functionality
Good and reliable software
Doug Thomas | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate for the replication of data in our brick-and-mortar source system databases to our cloud database. Our source systems are on many servers and we replicate them near real-time to a central cloud database. In our central cloud database, our users (product, data scientists, business analysts, etc.) can query the data directly. We also maintain data marts against the replicated data that are used by many different areas of our business as well. With Qlik Replicate we can tune replication to be cost-effective per data set. And, with Qlik Enterprise Manager we can manage and analyze all replication tasks in a single UI no matter how many Qlik Replicate servers we may have and, whether they are on Linux or Windows.
  • Many different source to target replication options
  • Common UI on Linux and Windows
  • Lots of task tuning options
  • Robust API (Enterprise Manager)
  • Easy to use UI
  • Robust scheduler
  • I would like to be able to keep task history beyond 30 days for viewing in analytics.
  • I would like integrations to more than email. Say, MSFT Teams channels.
  • Logging is great. With known resolutions to errors that are encountered it would be great to have more detailed context-sensitive help for faster resolution of errors. Especially if they are well known in the community.
  • I would like integration to source control for our at least our tasks.
We've found Qlik Replicate is well suited for near-real-time data replication from brick and mortar databases to cloud providers. We've tried a number of different options and found Qlik Replicate to be the one product that could handle all of our use cases without any issues. We also minimize any custom code needs as well as administration and application support needs.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We first used Qlik Replicate to replicate data from the Oracle ERP system to a Microsoft SQL Server BI system. We have also started using Qlik Replicate to replicate from Salesforce to the Microsoft SQL Server BI system.
  • Flexibility for creating multiple tasks for grouping related tables
  • Table level filters
  • The scheduler feature has been very useful
  • The scheduler, while useful, has issues when trying to create or adjust a schedule more recent than the current time UTC. That is the one thing I would really like to see improved.
Qlik Replicate is very good at cross platform replication such as from Oracle to Microsoft SQL Server.
Rajesh Chauhan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Operational Application Data (Oracle + SQL Server) replication to Data Lake (SnowFlake). The core capability is to replicate Operational data in real/batched mode to Data Lake as core to servicing enterprise data hub which enables Enterprise Reporting, Data Warehouse, and other data as application usage (Data Innovation and sharing at the edge).
  • Real time replication using Database Logs
  • Speed to setup and make it operational
  • Speed to business value realization
  • Applying the solution to SAP/HANA and other databases as source
  • Connectors/Adaptors to Tier 1 Cloud applications
  • Data type portability across multiple databases
A great tool to data replication solution for Oracle/SQLServers/etc. Fails to replicate data from SAP HANA via CDS Views and/or using SAP ODP framework. Only SAP HANA log base replication is supported which is not certified by SAP nor guaranteed for row tables. Real easy to get it set up and start realizing business value.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Qlik Replicate/Attunity is being used to replicate SQL server database to our cloud Snowflake database in near real time. It is being used to create strategic datamarts and dashboards to the whole organization and allows us to have access to the data without impacting the ERP production server with live queries.
  • Replication
  • Reliability
  • Incremental Speed
  • Full reload speed
  • Features such as parallel processing are not working
  • If connection is lost, a full reload is required to re-sync
Good for database to database replication. Salesforce connector did not work last I checked as it did not handle custom fields well and was erroring out due to row counts.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It is used as a replication service(tool) to copy data from one source to another(Target) and make use of the data instead of hitting the main source and that is used for all the data analytics. This solved the problem of the cross-platform join for the end-users who want to view the data.
  • Replication
  • Synchronization
  • Distribution
  • Support
  • Cost
  • Learning curve
Organizations should use this tool if they have a variety of data sets that needed to be in one place and do cross-platform joins.
Reid DeWolfe | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Replicate to ETL data from on our prem instances to cloud databases hosted by both ourselves and our clients. Our clients benefit greatly from having near-real-time data from our application available to them for analysis and integration purposes. Using Replicate allowed us to avoid developing our own custom processes and tooling for automating the creation of these ETL processes.
  • Reliably and quickly delivers data to and from a wide variety of endpoints.
  • Support staff responds quickly and helpfully to support requests and questions.
  • API coverage in Enterprise Manager allows for automation of administrative tasks.
  • The base Replicate web GUI is lacking. If you have dozens or more tasks, it's hard to get a sense of how they're performing. Enterprise Manager solves all of these problems but is a separate install.
  • The support portal is extremely difficult to navigate. It's hard to track down exactly what you're looking for.
  • It would be helpful to have better documentation and example queries for the tables in the Enterprise Manager analytics database.
  • Destination databases that don't support common DDL commands behave unpredictably. And the replication of schema changes isn't consistent.
It's a great solution if you have relatively static schemas and a limited number of tasks going to a small number of distinct endpoint types. In those situations, it can easily handle large volumes of data changes given appropriate host resources. However, once you end up with a larger number of tasks with a diversity of destination endpoint types Enterprise Manager becomes essential. Automating tasks via API is needed to keep management of the tool sustainable.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
As part of our migration from an on-premises Netezza Enterprise Data Warehouse to Snowflake we also replaced dozens of lengthy ETL extract processes with Qlik Replicate. This gave us one location with multiple system's data in near real-time for operational reporting as well as the ability to simply transform and load data into the Data Warehouse without the lengthy extract process. As a result, we start the process later in the day and finish much earlier despite continuing to add more data and complex processing.
  • Loads data from ERP systems.
  • Non journaled/logged sources can be run as full load only processes via API calls.
  • Monitoring and alerting.
  • Ability to enable source system owners to start and stop tasks for their maintenance windows.
  • A wizard for partitions for parallel loading.
  • Better way to analyze latency.
  • Better documentation for using flat files as a source.
Its great for loading data from ERP databases (iSeries, Oracle, DB2, SQL Server). Not that great for Netezza. Does minimal DDL (no unique constraints other than PK, no foreign keys).
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Replicate data from on-prem DB2 on z/OS (mainframe) database to S3 and Aurora PostgreSQL databases in AWS cloud.
  • Support for many source and targets.
  • Ability to customize replication setup (set locking level with connection string, set the replication key, etc.).
  • Straightforward and problem-less installation.
  • Lack of APIs on replicate server to automate and monitor replication. (repctl API interface on Linux replicate server is limited and being deprecated, forcing customers to use AEM server to control replicate box)
  • AEM server (web interface) seems laggy, nonresponsive, slow, does not refresh. Needs to be more mature.
  • Task scheduler is only available on replicate server web console. AEM should have the ability to set schedules.
Simple interface, Nice AEM GUI interface for non experienced user (much simpler that Informatica). Best for simple CDC replications without any ETL manipulation for companies with inexperienced stuff.

At the same time can be customizable with JSON config files. Biggest strength is a support for a number of endpoints (supports DB2 z/OS as source)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
For our main company-wide LIMS system to replicate for reports.
  • Easy to make DDL changes that replicate.
  • Easy to add and subtract tables.
  • Keeps up with very busy system.
  • Better explanation in help for settings to explain if change one setting how it could affect another setting.
  • A better recommendation on what to set for a combination of settings for certain circumstances
  • Make support portal much easier to use. Don't know when responding if respond to the latest comment from the support engineer or to the ticket - very confusing.
  • The responsiveness from support to be much improved. I couldn't get someone to call me on the phone to discuss everything which would take a lot less time than going back and forth on the support portal.
  • Latency alert to allow to be defined to continue sending every number of defined minutes like every 30 minutes if still above the threshold and hasn't dropped below the threshold. It's easy to miss the initial email so if emails continue to be sent then there's more of a chance to catch that replication is behind and something may be wrong or broken.
Good for a reporting scenario to replicate just the tables needed for reporting from another database.
July 16, 2021

Ease of use

Score 8 out of 10
Vetted Review
Verified User
Incentivized
[Qlik Replicate was] mainly used for Change Data Capture[.]
  • Change Data Capture
  • Full Loads to MPP system
  • Reading from log files from most of the sources in our case it is Oracle and SQL server
  • When doing CDC from SQL server
  • If we use Back up logs only then it doesn’t let us just add the new table we have to start the full load first and bring it to current and then start CDC
[Qlik Replicate is well suited for] change Data Capture for APS[.]
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used across the company to replicate ecommerce, ERP, finance and marketing data. In lieu of complicated data flow, it enables us to have a real-time data using simple method which are convenient for users. It can also be easily monitored and users will be notified if there is any kind of issue in the replication.
  • Low latency.
  • High volume data.
  • Easiness of monitoring.
  • Alerting mechanism.
  • Less impact on the source.
  • Hourly schedule.
  • Source to target comparison.
  • Renaming tasks.
We had to develop a database and make it available to users as soon as possible. If we used other tools to replicate the data, it might take longer time. But by using QLIK, we were able to set up the target database with less effort and less time. The precision is amazing and the latency was very minimum.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it to replicate data from SQL Server to Snowflake real time.
It's being used by multiple departments in the whole organization.
It helps in full load and replication.
  • Change processing option to replicate real time
  • Various connection end points
  • Load monitor windows
  • Easy to learn and use
  • Error message clarity is lacking and not easy to understand
  • Logs aren't user friendly to read
  • No downloadable client
Not useful if the source is restoring often.
Doesn't do well with new connection end points like Salesforce.
Jeff Huelskamp | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate as our sole on-prem database to database data pipelining tool within our IT department. It has lowered the time to delivery for us to load data into various data marts and into our Snowflake data warehouse.
  • Database to database data pipelining
  • UI/UX
  • Ease of use
  • Ease of troubleshooting
  • Needs to be able to connect to RESTful services.
  • Needs to be able to connect to SOAP based services.
  • Licensing model could be simplified.
Again, this product could be a one solution fits all if it had the ability to connect to and pull data from APIs and RESTful or SOAP services. We have to use other tools for that purpose, whereas we'd prefer to just one one tool.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
[We] used [Qlik Replicate] for replication of select tables from Oracle to SQL, and Oracle to Snowflake.
The data is used company wide from their endpoints in order to run reporting and dashboards.
  • Getting data from Oracle to SQL.
  • Quick and easy to set up.
  • Maintaining tasks is quite simple.
  • Duplicating tasks for different environment setups is not easy to do.
  • Task performance tuning requires help.
  • Knowing if the application host system is doing well is hard to figure out.
  • Inability to monitor Replicate without add-ons is impossible.
Depending on the use case, I'd definitely suggest using Qlik Replicate, especially for data transfer. I would not suggest it for doing ETL/ELT systems, unless using other add-ons, such as Compose, from Qlik.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate in one specific vertical within our larger organization. We are using it to copy transactional tables from our CRM database into a data warehouse so that we can build a business intelligence suite on top of that data in an OLAP database. Qlik Replicate allows us to easily copy that data without our having to build our own custom, real-time ETL processes.
  • Replicate is extremely stable and does not generate a lot of alerts/failures/issues that take up time to troubleshoot.
  • It is very easy to add new source tables to a Replicate task so that we're always in sync with new data available from the CRM.
  • It's nice that Qlik Replicate also allows you to create a job to stop and then restart your tasks during maintenance windows that occur on both the source and target systems.
  • I wish there was a way to give the user the option to decide if changing a particular task setting actually requires a reload of the target table. Too many changes or modifications within the task settings require you to reload a table and if the target database and source database do not have the same data retention policies then you risk losing data and you have to account for that when changing task settings.
  • From time to time a particular task begins to build up latency where it becomes 2,3 or 4 hours behind the source system. It's never really clear why that is occurring and it may be impossible to know exactly but I wish there was a way to know that it was due to activity happening at the source or the target.
We don't really use a lot of the more advanced features of Qlik Replicate (like transformations) but I feel like Qlik Replicate is very good at the simple 1:1 replication of source to target. It provides you a way to view change tables to see how/when attributes within source tables changed. It's great for business groups that may not know as much about building an ETL but it would get the data they need into a non-production environment to query/investigate/report on certain aspects of their business without the necessity of a giant IT budget.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We have recently implemented Qlik Replicate to move our data from two different data platforms to one. The sources are Oracle and DB2 and target is MS SQL. We used to have a lot of challenges utilizing the data from different platforms on reporting, analytics, and supporting downstream systems, which were mostly utilizing the SQL server. After the implementation, I think a great amount of our energy is saved and we are engaged in more productive projects and are able to to utilize our time efficiently.
  • Qlik Replicate brought a great experience with respect to the ease of implementation and great UI. We had a software that was a blackbox for the team and was very hard to maintain. Qlik Replicate implementation helped us avoid dependency on one resource.
  • Global transformation and in-built functions are what I like in our project.
  • You can customize the conversion/transformation using a JSON file generated by Qlik Replicate, and it is very convenient.
  • I think Qlik File Channel need some improvement.
  • Sometimes log files are not getting deleted when you push it to purge on UI.
  • Upgrading the software should be a one-click task. The software should be intelligent enough to back up the required old version of a file in the archive and apply the patch, and if all goes well, purge the archive or else it will revert back.
I have used this software earlier also, and this is the second place where I have suggested the management to try and the IT management liked it in the first demo. I liked this software because of its easy-to-use features and powerful engine to replicate data from different DB platforms.
Rich Fox | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We currently use it for one department. We have a centralized application that we use Qlik Replicate for bidirectional replication (hub and spoke) to sync up data with 90 sites, filtering so only transactional data related to the target site is replicated. This permits an application that was not developed for a WAN environment to be utilized locally at branches without issues of slowness or downtime caused by the network.
  • Very low latency with large transaction volume.
  • Central management console (AEM) for monitoring and managing many tasks.
  • No daily maintenance. Process is basically on autopilot.
  • Quick and easy to create or modify tasks.
  • Filtering data had some unwanted side effects.
  • No ability to do full loads with bidirectional replication.
  • Ability to use LOBs with upsert mode.
  • No ability to push/pull from web services/APIs
We have had very good luck using Replicate to sync up tables from one server to another. The two main reasons we are doing this are for data warehousing and for turning a local application into an enterprise solution.
Return to navigation